**** Generating Impact values for journals

import excel scimagojr 2016, sheet("Sheet1") firstrow
keep Title SJR Hindex CitesDoc2years
rename Title journal
label var journal "journal"
replace journal = proper(journal)
save journals

**** Merging impact values onto database

use sociology, clear
replace journal = proper(journal)
replace journal="Journal For The Scientific Study Of Religion" if journal=="5Ournal For The Scientific Study Of Religion"
joinby journal using journals, unmatched(master)
drop _merge 

**** creating impact factor database
keep articleid SJR Hindex CitesDoc2years
save impactfactor
